USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MedicChargeSelectCountByPlayerIdLogId]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.MedicChargeSelectCountByPlayerIdLogId
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Maps Select By Name
-- =============================================
CREATE PROCEDURE MedicChargeSelectCountByPlayerIdLogId

            
            @LogId int,
			@PlayerId varchar(30),
			@ChargeCount int = 0 OUTPUT
	
AS

BEGIN

select @ChargeCount  = COUNT(ChargeId) FROM MedicCharge
		WHERE LogId = @LogId
		AND PlayerId = @PlayerId
		

END
GO
